TOP 5 慢查询

SELECT `id` AS `id` , `apps` , `user_id` AS `userId` FROM `apps` WHERE ( `user_id` = ? )


SELECT `id` AS `id` , `order_id` AS `orderId` , `report_id` AS `reportId` , `content` , `comment` , `pan_code` AS `panCode` , `phone_number` AS `phoneNumber` , `aadhaar_no` AS `aadhaarNo` , `date_of_birth` AS `dateOfBirth` , `body` , `old_body` AS `oldBody` , `status` , `clients_uid` AS `clientsUid` , `score` , `user_name` AS `userName` , `bank_account` AS `bankAccount` FROM `gct_report_info` WHERE ( `clients_uid` = ? AND `content` != ? )


SELECT `id` AS `id` , `order_id` AS `orderId` , `report_id` AS `reportId` , `content` , `comment` , `pan_code` AS `panCode` , `phone_number` AS `phoneNumber` , `aadhaar_no` AS `aadhaarNo` , `date_of_birth` AS `dateOfBirth` , `body` , `old_body` AS `oldBody` , `status` , `clients_uid` AS `clientsUid` , `score` , `user_name` AS `userName` , `bank_account` AS `bankAccount` FROM `gct_report_info` WHERE ( `clients_uid` = ? AND `content` = ? ) ORDER BY `id`


SELECT * FROM `interface_invoke_count_log` WHERE ? = ? AND `create_time` LIKE `CONCAT` ( ? , `DATE_FORMAT` ( NOW ( ) , ? ) , ? ) AND `user_id` = ? AND `type_interface` = ? ORDER BY `id` DESC LIMIT ?


SELECT COUNT ( `handle_code` ) `triggerDayCount` , SUM ( CASE WHEN ( `trigger_code` IN (...) AND `handle_code` = ? ) THEN ? ELSE ? END ) AS `triggerDayCountRunning` , SUM ( CASE WHEN `handle_code` = ? THEN ? ELSE ? END ) AS `triggerDayCountSuc` FROM `xxl_job_log` WHERE `trigger_time` BETWEEN ? AND ?